package ylsb.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import ylsb.model.Yiyongjieguo;
import ylsb.model.YiyongjieguoExample;

public interface YiyongjieguoMapper {

    Object getResultCount(@Param("xiangmuid") String mmxiangmuId,
                                       @Param("userid") String mmuserId,
                                       @Param("result") String mmresult);

    List<Map<String, Object>> findResultBypinzhong(@Param("xiangmuid") String mmxiangmuId,
                                                  @Param("userid") String mmuserId,
                                                  @Param("pinzhongxuhao") String mmpinzhong);

    List<Map<String, Object>> findPinpaiResultAll(@Param("xiangmuid") String mmxiangmuId,
                                                   @Param("pinzhongxuhao") String mmpinzhong);

    List<Map<String, Object>> findPinpaiJieguo(@Param("xiangmuid")String ppxiangmuId,
                                                         @Param("userid")String ppuserId,
                                                         @Param("pinzhongxuhao")String mmPinzhonxuhao,
                                                         @Param("pinpaixuhao")String mmPinpaixuhao);

    List<Map<String, Object>> findByxiangmuId(@Param("xiangmuid") String mmxiangmuId);

    List<Map<String, Object>> getPinzhongpaixu(@Param("xiangmuid") String mmxiangmuId);

    List<Map<String, Object>> getPinpaipaixuByPinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhongOne);

    List<Map<String, Object>> getAgreeListByXiangMuIdAndPinZhong(@Param("xiangmuid") String mmxiangmuId,
                                                                 @Param("pinzhong") int mmpinzhong);

    int countByExample(YiyongjieguoExample example);

    int deleteByExample(YiyongjieguoExample example);

    int deleteByPrimaryKey(String id);

    int insert(Yiyongjieguo record);

    int insertSelective(Yiyongjieguo record);

    List<Yiyongjieguo> selectByExample(YiyongjieguoExample example);

    Yiyongjieguo selectByPrimaryKey(String id);

    int updateByExampleSelective(@Param("record") Yiyongjieguo record, @Param("example") YiyongjieguoExample example);

    int updateByExample(@Param("record") Yiyongjieguo record, @Param("example") YiyongjieguoExample example);

    int updateByPrimaryKeySelective(Yiyongjieguo record);

    int updateByPrimaryKey(Yiyongjieguo record);
}